SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584403 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584403 [ RunTime:0.002278s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024823,610929,644915,19252,287081,563532,435258,227810,636680,353196,591228,722522,362838,540051,124324,822514,171998,418970,453544,873854,316152,729808,350933,860019,64140,454141,1012093,1004128,569677,574580,310494,8617,893446,1032909,436947,640150,966539,492825,556693,178660,291111,274598,64277,417056,995679,36824,908393,133404,421546,70601,903927,482848,607640,872342,523042,560035,246645,1011719,719053,92637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]