SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38121 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38121 [ RunTime:0.002518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251437,657503,185026,663471,113276,982429,270895,924681,976292,582740,988016,195484,408827,180777,624650,301593,856240,423180,433919,19969,968232,662880,5782,14255,1011244,61109,388954,718162,17141,959967,1011786,738240,999271,353807,797616,548300,389791,1002744,488553,16792,632503,276878,459367,927097,407062,376042,656999,176178,869925,128337,692205,1000840,947286,1009815,467166,117445,485396,731941,72481,500084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38121 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38121 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]