SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52000 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52000 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499241,975402,477490,150819,85534,710822,1039721,214258,842573,150992,575850,740806,924383,185440,199984,702572,1040742,1008959,128382,1048418,804888,718552,98999,853724,1016643,9521,309308,938427,223386,371097,899731,628754,731755,861720,658527,920170,1047950,355144,152591,477876,812486,833060,895989,952775,679131,568106,585937,269742,782960,497019,874616,319192,612997,109540,112856,993761,845235,1009387,649890,608298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52000 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52000 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]