SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559405 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559405 [ RunTime:0.001553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107836,857003,415218,530459,989018,16312,741142,41479,973257,224309,269100,196985,712308,154050,622104,789071,10214,735502,499076,128347,441905,363811,967278,795081,1002092,157235,752505,518637,612627,212062,177117,327518,144298,945756,280751,386061,899415,562292,829265,732886,159620,380908,838389,624083,103649,287737,652670,1009629,614169,528105,270495,159580,754142,497000,862357,463880,730259,627162,62889,416553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]