SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 928912 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 928912 [ RunTime:0.002121s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420252,588345,991004,48746,239634,877931,634449,657383,308891,1007200,923810,649664,169387,899983,429285,595962,289700,465257,566489,559922,162915,570534,726704,711724,52139,760600,264268,830526,363313,157154,859593,1008093,497958,804660,553828,222163,82434,1043064,548752,294146,198307,624337,331234,122185,276360,1021082,489414,771375,903300,43412,66949,832679,1012690,835688,609742,767442,521305,99285,736117,85578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 928912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 928912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]