SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412151 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412151 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938658,517648,26352,951695,796674,770387,325865,114517,1006180,844700,685744,1043214,813753,544082,672351,642659,21187,368792,347551,7577,550507,802435,456571,148816,839044,204645,852760,996531,904985,435987,982401,885398,852798,819279,478590,813243,134291,923145,2390,773611,425810,242947,464248,836731,415252,888591,598846,572650,67091,320234,811697,318535,310692,451623,993029,55094,404486,329866,763425,277548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000899s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]