SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038709 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038709 [ RunTime:0.002727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (770636,392516,275184,591909,112892,225683,820769,272523,537945,777596,578950,322257,311306,461806,335702,1039644,327895,800830,1026491,180381,759925,453487,113145,430474,446834,518013,321798,62876,218337,627228,236626,526339,363456,712693,849596,341961,332151,279653,597352,300627,932236,438737,602131,349430,647666,136356,831007,495924,311423,246086,398755,229737,152651,258264,694239,309168,501099,674983,410674,525371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038709 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038709 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]