SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491210 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491210 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852588,176120,855925,271187,632112,983125,316424,1025592,254115,271742,371882,436013,563442,12908,424705,322369,792460,581833,704763,143637,564173,613579,762407,274544,611792,845633,82712,181617,480987,657427,222779,773233,558531,111617,559251,125325,1014344,92163,480685,48831,601345,418609,562427,227795,915924,435403,838860,255638,563385,302726,389195,346227,376234,973340,599071,507728,658344,422609,493216,977114) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]