SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551029 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551029 [ RunTime:0.002011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51022,10357,344196,741768,354562,1014786,225305,981204,406584,833133,547171,129908,318969,214725,480520,453378,454238,941923,126227,217098,327536,106088,180019,871227,289936,108380,902799,65934,220810,644680,836895,168213,319558,25185,152914,652182,144653,992146,128737,646284,417995,827231,516932,885258,36957,864981,790858,482886,714103,730160,877193,260557,149012,558942,301311,563708,140756,731835,399152,58128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]