SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544891 LIMIT 1 [ RunTime:0.000811s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544891 [ RunTime:0.002410s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619730,303380,33830,645204,461033,892854,50351,181988,680612,890700,814829,816706,150023,746982,745994,688484,406375,72246,202088,577858,779611,312354,814265,989315,636491,166789,341538,175339,262855,77181,775593,186918,762061,825169,924555,556442,366536,357125,854852,380562,689272,752206,551606,780655,158052,382158,291291,399584,434571,369008,889553,203534,144531,485942,506324,1005421,521622,977013,610091,555786) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004751s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000839s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000986s ]