SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 339909 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 339909 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610222,227105,133338,973596,102518,696853,523705,340879,611542,591586,682598,394579,964130,73220,113895,126869,998650,398553,490087,817037,73441,197026,192675,215700,147443,407596,155227,853737,749110,351570,15917,801280,632283,521253,831690,501220,822599,820240,624074,470099,376473,519498,398309,557250,705232,732277,258284,180585,979647,446152,610644,899619,618914,519281,758380,528528,157350,494141,132306,802349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 339909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 339909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]