SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001593s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 178910 LIMIT 1 [ RunTime:0.001009s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 178910 [ RunTime:0.002070s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684858,413443,1001860,976244,122832,778638,484056,358760,309330,962324,911048,843262,547732,183490,1011562,291866,130689,439079,412171,56822,789515,911540,970853,946588,923610,752837,423332,954223,375484,753163,330588,565139,109104,673809,835936,212616,469767,681980,927076,426211,946205,111297,747786,297560,1043395,97249,331114,344481,688977,623090,548885,460654,193826,80878,998946,799652,536349,773630,136750,424467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 178910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 178910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006871s ]