SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428474 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428474 [ RunTime:0.002666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570510,434604,647226,37748,179125,459638,6299,666875,1007569,602003,986732,667126,161810,922552,86576,281618,264551,660743,75962,285762,285203,906360,395005,812501,580935,407711,451706,124486,427713,284796,689801,609858,20478,108400,913164,687411,122447,44223,316406,373623,409546,656534,358613,563809,297721,500086,396015,990628,1753,683020,251540,121849,505922,292699,641221,433802,152379,547391,412652,234145) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000969s ]