SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405515 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405515 [ RunTime:0.002836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58851,575403,343060,1000443,152319,832363,162717,278594,373956,647942,424205,580045,453707,87524,862279,690661,897586,637871,35,401067,103384,210413,339389,1006030,283338,881929,460845,671905,935115,352678,282459,1040971,213724,349955,183267,322054,971957,1046466,156785,293511,48878,404007,352761,648692,433729,614871,91967,859342,448648,510649,73440,788002,632344,430433,592478,33815,745167,667282,975875,492566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]