SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006644s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414586 LIMIT 1 [ RunTime:0.003401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414586 [ RunTime:0.007455s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482121,905164,314076,457305,54762,110801,424057,568560,749036,570997,983503,583987,330745,1000127,405159,859510,441308,292984,58068,422271,136186,57969,414858,983878,1028819,267417,644524,844819,251378,788291,234662,697967,272554,36109,449202,442762,495873,714594,4572,313663,298012,240735,767884,625986,196224,952618,95691,954093,664031,831147,661091,778165,383915,961383,710198,81259,464155,838385,1031643,223798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013824s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414586 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005808s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414586 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001851s ]