SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300651 LIMIT 1 [ RunTime:0.002005s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300651 [ RunTime:0.006059s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197708,504566,928502,553914,608413,607980,776143,380918,850237,256301,347337,59343,506975,672546,507489,441574,553355,613911,200634,1027539,982017,427155,411601,1003624,918151,112667,507190,764202,267516,947648,598334,1034544,501401,779182,726991,966147,732889,406989,659179,229361,981002,998773,96551,325252,1013150,15073,38284,879165,861244,586562,155772,415687,1038842,54928,880927,439242,445652,747629,10714,471339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002983s ]