SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012930 LIMIT 1 [ RunTime:0.009047s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012930 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (2500,393641,14504,448571,531885,1016570,940744,213857,129102,17782,616250,86004,49956,784204,339214,392670,920190,942165,39176,527399,224967,201681,763925,791423,87180,722113,1020357,706250,54503,965267,232643,746155,687134,499915,441390,710130,15817,1034136,542704,980139,157216,866549,849289,847782,971114,731019,1026367,215564,660229,793519,31458,778427,689039,277486,920025,44424,194182,265283,918491,1022577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000850s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000710s ]