SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400864 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400864 [ RunTime:0.003177s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (272040,704645,1001456,527761,186551,756821,409251,570463,14340,782285,513750,805172,524434,621973,601195,989955,571361,716705,693811,920278,405585,156144,190568,492660,228700,503491,452139,877629,752145,756898,663077,222172,209151,523786,867457,1010353,429137,1027678,1035635,994774,292944,468754,244829,161796,232780,231963,907638,694898,1047795,29028,707058,307388,189709,738867,48204,464437,782256,774995,553587,758863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000914s ]