SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014042 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014042 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529336,780912,521849,506928,581851,408054,935363,102138,664217,176410,713408,434351,616040,307548,366529,876280,1001589,282810,616000,601383,333856,1025576,684852,249206,109212,451788,467591,25923,49173,349892,865729,725751,558039,455716,492642,678813,80324,518256,826166,839748,114480,287414,80767,444114,944244,419565,806687,501566,209040,916950,988187,988321,848690,529550,269185,666896,711083,670725,992023,1018372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014042 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014042 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]