SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101490 LIMIT 1 [ RunTime:0.000696s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101490 [ RunTime:0.002870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813098,802171,513220,1029704,904618,929182,942758,104164,933094,138001,402468,618571,74650,618653,184329,291610,143656,771743,251278,133068,86215,384879,666106,661053,741810,680537,296192,220069,374453,730673,812854,225042,925694,1018104,11318,456239,586866,458020,491255,450843,254217,172936,751108,105074,13438,988565,492206,714776,138842,354941,1010771,466901,301556,814524,665973,907548,527338,245354,514615,389570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101490 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101490 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]