SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 935864 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 935864 [ RunTime:0.002003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532178,214601,690142,1039368,265088,945404,1004020,381441,946148,423307,246024,932427,291154,429586,598700,602249,325305,532960,1000960,53398,218015,77064,979058,410858,293888,785536,521646,450946,150335,672185,500107,914467,29232,732195,350427,365209,881514,194427,613476,227710,3241,1043754,457747,124423,391834,683957,132698,419129,763975,834658,155507,47925,640498,98116,697237,789597,288277,343958,736136,514005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 935864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000624s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 935864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002136s ]