SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001530s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311001 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311001 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003634,573202,426626,253103,141258,640803,692404,654877,37313,402078,100943,706586,505589,504741,209795,467017,955257,114708,121832,732189,16707,263275,958342,580163,5361,581252,769822,111267,428075,593330,218507,187113,854321,355088,36148,326640,734550,858533,593729,388845,234087,293667,330826,369196,578257,98163,345163,192822,242603,986763,517745,205609,687523,728906,539473,1015156,487819,874513,585030,1010184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001767s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000769s ]