SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349634 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349634 [ RunTime:0.002106s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6512,87956,389916,772996,560938,812489,433953,300451,11783,697736,114812,726670,1038302,362724,829509,819872,324361,277844,335118,409102,4739,335922,450533,779377,186902,35855,333852,236505,26177,545793,264458,617120,575018,170212,962278,344547,607856,542836,336113,604961,355636,331793,866959,28917,21236,217561,1042785,86239,951446,371209,231179,15205,859418,849638,444130,426737,39127,175153,769325,25703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349634 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000688s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349634 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]