SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410015 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410015 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019179,712443,287191,593924,1021500,6723,41630,620335,288673,431104,404263,1038533,132703,288191,1018545,550811,64256,234936,710033,92578,589033,217922,145907,301608,896142,947485,906160,1018125,826054,1002203,789320,710274,1002792,692529,909110,21180,829067,846930,468401,731601,912285,522200,482169,881892,727571,608676,236638,509069,930963,550411,452748,759829,629776,830057,507772,961444,148322,888483,892595,355219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]