SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 296791 LIMIT 1 [ RunTime:0.000731s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 296791 [ RunTime:0.005200s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285428,812115,11623,779768,503491,602049,694306,683293,691989,993468,993372,929348,401213,37610,967473,141104,148868,742916,751440,227686,970204,652290,484167,179688,884096,386376,4312,66517,38246,179301,918868,30350,503277,871118,122933,133237,77471,539699,552532,136615,103643,859788,160755,739099,357756,471357,997748,704644,231523,755573,62713,816398,227896,182172,1019093,519318,216281,20088,509526,646811) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 296791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 296791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]