SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004619s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539782 LIMIT 1 [ RunTime:0.001117s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539782 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454890,139551,893488,589031,593753,842093,1018336,657523,733674,253756,91966,144392,119990,240881,603143,190124,28881,1008381,718292,599013,768847,882604,403467,112511,2588,775827,492164,31424,114869,1045365,545253,1024626,62531,523848,327954,712423,166379,116306,611484,714217,137536,440054,127193,806368,878283,640694,1048375,747353,314297,695410,633672,463426,891962,251309,281866,717405,873504,768385,917543,505846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539782 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539782 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]