SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012117 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012117 [ RunTime:0.001402s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (957883,883411,355296,180522,104771,637420,286247,498489,182151,878557,531044,815515,481103,960976,551872,272181,527838,490403,328226,226233,259160,455843,131459,467878,862109,339463,578420,34676,866644,604045,348988,450908,340884,625099,290757,649612,808883,866295,180387,838902,532978,821163,774290,364470,71689,234130,266495,969997,609850,143086,971100,1001174,852193,310193,924801,697957,761727,325201,303315,501148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]