SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262416 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262416 [ RunTime:0.002772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011624,1045867,508454,790849,483485,226301,798108,199014,117438,1003941,172457,423322,462750,504378,151604,501061,237164,400467,637201,198260,764149,119204,966446,74587,20194,55929,971918,351899,283580,656868,380266,420937,423426,321104,572776,128199,58136,806545,812535,604853,989845,18877,490107,371342,915891,542902,611204,783375,405380,699420,615568,623375,889991,924851,844120,82990,426039,375524,435392,375233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]