SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320831 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320831 [ RunTime:0.002704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293317,899247,739114,76815,48734,6626,552244,1047667,849646,666049,365573,769415,243873,981698,1048599,93948,68784,299437,9386,728612,860169,603339,146883,786032,712941,1024862,232807,742737,948618,511138,34841,1019204,439710,525944,542513,536565,257010,1032625,681894,1036131,427116,869755,418438,98222,776196,775630,605247,315261,39959,390531,337577,598329,992950,667088,542242,12437,646637,421452,460845,782162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]