SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292910 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292910 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874900,870226,623768,139344,270651,868672,237502,1045744,70167,353134,96061,412157,382111,917293,756526,783598,1032344,115715,575167,356437,62022,97664,631866,401210,136450,357118,144100,207978,527846,955680,302896,1000983,411385,500599,702294,280598,848529,385038,107459,491997,814815,416469,812085,492694,782629,605821,481017,6634,641261,170761,1038467,638536,122851,256200,624738,115683,997807,534798,323652,225001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]