SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001642s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291430 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291430 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (662246,914889,605222,641968,453178,840834,1003232,572178,453237,948442,976640,414089,867833,393623,611996,80002,515366,772957,180079,44630,636253,1006989,446611,988150,159895,368175,631945,909097,623387,457389,1020662,624480,969304,635524,754032,262033,254176,590338,134248,88669,100895,900859,892634,696930,988170,1023566,98110,999469,753313,665728,337639,63429,868451,191247,504404,189236,808046,749946,697388,824679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]