SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001577s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473980 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473980 [ RunTime:0.002659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195853,228543,814133,179834,498247,956833,747454,790834,430011,577497,189011,702383,938569,355039,617088,1042325,350643,221772,696407,73546,476370,590711,863220,671656,496320,857390,893487,926846,583802,995187,784389,743995,349020,659948,644908,217561,81513,806118,864471,206580,584096,977905,161586,184640,1002331,227968,724664,603604,820444,377739,21882,532592,1004950,152865,559389,907041,269118,556950,864429,941924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]