SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406420 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406420 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342654,567419,1028440,679160,442375,809933,132712,906689,1046490,160031,192417,697411,159842,112601,422062,586119,971223,667071,828512,18553,933626,108360,257756,419858,735992,934485,777594,416401,899904,370436,634119,104820,220864,1035605,620237,648241,223187,171338,465485,731871,1001131,157712,97111,240543,962777,216103,193769,814894,900547,724780,819543,173699,985001,1003084,973895,719379,729841,359961,817694,952447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]