SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040319 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040319 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (934098,696331,656494,190537,128998,931257,682994,397631,319788,90769,407012,808505,732962,551093,559850,425012,281129,729928,322225,694299,755156,39382,727291,497743,905985,427900,512209,56983,288739,934625,817759,102547,331024,1037742,831312,211727,896590,628539,242239,531241,635522,375907,155032,468299,744395,394608,707677,819533,637853,794486,539781,1006307,875586,938624,854149,648517,603270,728662,105287,1002504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001200s ]