SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004722s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421800 LIMIT 1 [ RunTime:0.002732s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421800 [ RunTime:0.003520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421733,687429,114020,532864,46471,1035539,499583,1014341,540643,755112,402226,973640,579141,221241,825234,981342,326658,207703,1020470,691807,277253,361074,814378,243406,770002,464100,544966,152900,893552,441917,620189,859003,360052,548767,1005591,737819,653266,64576,109119,153225,966969,512592,972044,991007,850059,279833,914111,125014,927681,848040,666965,552141,479289,751207,549488,993088,802169,938183,97336,100974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001085s ]