SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 7210 LIMIT 1 [ RunTime:0.001340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 7210 [ RunTime:0.006755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339715,857715,747521,884346,193250,716918,295562,102316,771913,370595,164885,22003,272963,352846,41425,103079,180513,976678,751478,1038792,94515,965216,104844,1031326,136297,541695,211019,668712,891471,121467,649105,435323,98686,988938,300913,24064,328899,149790,527020,364586,137922,140778,809002,229921,736605,383188,884043,441285,105457,414635,521918,653498,328670,992803,760610,210040,697759,507902,39672,144866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 7210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 7210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]