SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418964 LIMIT 1 [ RunTime:0.000767s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418964 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337096,401068,361152,123516,900579,188214,802342,7521,150328,70120,1018363,939326,395222,374736,87109,61900,670365,620045,198531,573620,470831,952600,1004776,348885,972366,61572,341614,483790,840410,199504,676745,238187,70719,127063,560489,769865,44819,492932,492518,266029,965669,84922,635838,589900,218800,436916,213275,1029464,95076,830347,695868,759790,69409,726829,873016,588655,21939,580042,917305,863192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]