SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004565s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106968 LIMIT 1 [ RunTime:0.000837s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106968 [ RunTime:0.007252s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477212,842519,331531,394625,980078,709222,585496,451134,548369,739040,625077,1013219,683387,1002042,341830,159579,259038,793068,400471,490070,37145,608771,860537,397517,1029540,190037,301682,774690,550343,700723,315451,661733,654899,510227,1041021,587911,186124,953973,356377,674994,445041,782519,815632,430566,43299,754382,985487,720818,741023,271536,346891,585472,324594,734009,340088,905562,677195,689757,822090,94697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000825s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001761s ]