SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003662s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 231880 LIMIT 1 [ RunTime:0.000532s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 231880 [ RunTime:0.002788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164617,538579,715542,546885,910821,697787,1006180,982000,1033272,941667,105356,66140,310151,201208,808992,545523,176808,404741,419973,984400,589837,249300,306180,76462,289108,868578,96781,472119,517788,548709,91900,728139,424677,4349,685311,1021168,868275,72930,905681,800643,711855,580747,411609,134407,531467,49172,853869,35582,454663,845892,1002725,245775,373295,763948,825875,848770,52428,1034995,533924,654183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 231880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 231880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]