SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001451s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54110 LIMIT 1 [ RunTime:0.000548s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54110 [ RunTime:0.004712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446053,426920,510271,463993,557079,1038815,367100,449699,865139,15397,386869,548915,1019242,692157,282233,769146,607730,183539,552088,809397,1036302,450910,749310,826649,883988,79986,347063,504616,404760,18852,932535,458391,715067,938646,87293,559479,998032,13248,490271,631623,878210,392784,278608,708914,378640,338933,903596,433998,176321,812500,341109,77515,871297,247647,262223,319446,693883,728453,347588,35793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]