SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046666 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046666 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50968,68199,561280,942754,906654,615477,941879,377312,654854,908648,542373,312390,345857,236371,866591,1011881,110023,613864,229851,340337,177192,1047976,648777,445871,252928,340520,486560,267440,990662,132871,755282,151898,401321,777717,994223,787659,36146,18921,904417,40364,156133,1026157,830149,153180,973935,417552,394088,1003399,960947,1046817,1023963,872039,457619,103711,1018726,907579,284555,105692,243578,757713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046666 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046666 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001433s ]