SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109910 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109910 [ RunTime:0.001487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768342,252032,288129,145725,772307,748400,327369,605278,778691,61313,930998,1033659,1019592,853941,449436,26010,237476,45049,638326,864806,438706,911958,482920,551324,423196,53926,54556,12476,534909,463358,352906,1010733,350023,808608,627164,763269,143061,959395,625856,682685,990001,11416,578494,412708,314968,897547,828484,694803,704936,999874,24351,716222,993602,663384,575382,154258,250316,770383,491025,33555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]