SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001529s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468873 LIMIT 1 [ RunTime:0.000618s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468873 [ RunTime:0.001945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (832880,147711,1037988,873981,655929,464625,137754,428304,489752,426157,553107,623752,203643,46819,993438,717472,379752,189225,58848,486169,799368,897601,815532,834466,774182,839742,12189,903778,150165,863117,415569,332455,954297,516257,1023980,940826,802928,232964,560840,716997,485425,471169,450475,125085,1002277,836709,1041226,52493,64757,506298,807675,829468,970844,151269,162634,580722,31104,322578,1010903,375781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.025990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468873 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468873 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002219s ]