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` = 547809 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547809 [ RunTime:0.002924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (767023,701628,302877,443686,196567,100377,643816,97263,259580,611796,545963,78161,234421,247460,352028,867118,215541,681363,708659,210857,164623,1010991,775930,872083,554250,328603,10524,82183,334834,319287,137127,331445,787685,85894,226932,201086,288485,277320,167760,454575,250777,561878,480121,852787,73455,376500,581772,455114,105151,237750,855105,334012,50942,965649,846786,948415,364815,559763,37081,507826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001393s ]