SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406144 LIMIT 1 [ RunTime:0.001160s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406144 [ RunTime:0.003803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000578,375843,1025813,631049,633594,290265,931746,168850,77163,158020,734423,523476,226748,407931,961133,295841,903687,226020,677260,868476,618281,576206,800464,872525,442464,264102,579568,57313,644425,433422,179137,622852,1028160,492534,724559,892912,644100,64870,3932,870221,242702,1018816,365891,715096,347940,647700,736105,128919,890777,1013692,753778,579607,249587,208432,973258,649551,583750,65708,630427,421358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.037117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002417s ]