SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334893 LIMIT 1 [ RunTime:0.001972s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334893 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (731195,868595,1025796,878734,843713,362098,974175,430661,697065,52983,612214,1028148,794613,939394,294443,153562,660892,886290,492723,126391,357364,853936,199358,481748,621535,529102,26025,480182,265341,12437,788414,703798,787547,340562,298996,237806,1017986,36114,567558,610502,418028,34096,789825,214186,567986,532156,787217,17195,1292,935416,604936,432945,836359,643800,308749,46957,98590,536133,62441,872280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]