SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50264 LIMIT 1 [ RunTime:0.001693s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50264 [ RunTime:0.003019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576520,605934,514791,749818,783964,54948,140388,492077,589163,467491,643219,1019108,901971,414252,668037,358481,894951,559029,229621,456304,781101,502691,969349,40881,682935,524636,985906,608986,538213,765498,623642,969766,563251,180293,94286,400037,170876,751787,927342,805038,118288,305217,33208,573741,294370,219579,65367,205032,399133,692896,571279,749808,345752,288959,29541,655039,680747,890179,204569,488308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50264 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50264 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]