SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312003 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312003 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (232281,363133,124090,176668,852379,1004732,771888,283963,489907,111777,937346,601446,658309,141038,513593,356824,86464,870743,1009766,674086,1003568,850959,407006,393125,98314,402931,404081,470692,30726,905466,914096,734461,201848,871061,43609,788114,41640,914934,610740,1045063,336909,608746,748584,517455,36339,95181,975332,916334,823228,982854,720527,67125,780806,393424,577756,1012879,760142,189121,462676,65598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]