SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549307 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549307 [ RunTime:0.001968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610350,705740,401545,449674,544159,939131,102201,6460,245514,62186,26416,947899,116345,896801,205299,386880,530398,793286,1047668,166816,503441,489205,459365,642639,4740,702403,874830,113131,166772,408319,892987,32584,801814,517047,540745,586002,995477,584559,584046,920692,380585,13042,5627,850937,120023,100336,83081,596439,431929,125387,132516,313745,986835,438135,856494,95217,205365,117873,788660,267177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]