SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10107 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10107 [ RunTime:0.002417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231076,647604,801753,694654,21449,486656,477529,436324,1036639,385267,616155,559665,486973,962993,520072,181574,967750,789245,381448,2855,166233,509063,242374,172234,187774,570033,798331,203437,618004,123313,255314,308505,146869,806100,890921,973133,328892,259190,546586,968780,257549,361386,167504,827824,531905,148480,101432,1040281,81713,167492,106333,208508,489765,580685,1042857,386328,596757,596680,281858,148539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]