SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003050s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407929 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407929 [ RunTime:0.002228s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819157,133051,502403,10434,182854,341690,407621,245566,1040079,439228,396764,890375,1019614,651146,477654,651173,626934,656128,608559,18127,507904,730265,579304,847669,448144,912432,225299,89877,347791,656653,1000182,512067,325109,279854,931962,355531,44108,154276,580922,944154,201052,127156,901180,131146,472416,147066,685025,623821,977114,546324,726327,34378,348677,586915,682421,508513,1020823,169188,862830,758959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407929 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407929 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000899s ]