SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483947 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483947 [ RunTime:0.001909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476176,676223,627345,514964,380051,560951,595853,448550,285365,592109,985521,893285,413741,693832,805211,527139,121049,368696,955576,738908,1000070,221366,1046948,311055,431275,649894,1024755,678607,653619,510403,256481,643671,247606,96285,117794,907751,846789,654185,260354,557596,619578,393375,425321,713066,236777,56859,824153,351331,343813,702732,634102,252179,75471,476513,558155,489206,92513,183951,65510,704788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483947 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483947 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]