SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006696s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006985 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006985 [ RunTime:0.002811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388528,437883,461978,238478,612973,877434,69628,397617,56517,470519,113570,996640,893315,1045086,745898,646995,108072,997668,227262,860074,556114,209910,661657,711370,418019,127345,362258,889029,672104,196904,702206,187423,557987,262570,50893,516293,224974,607708,444120,929479,450184,903417,494634,55954,812029,819789,746390,801699,465250,610670,22705,934584,520618,522083,990575,753301,419241,153800,870700,206841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001655s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001802s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000910s ]