SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504104 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504104 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606186,367575,647314,317035,162241,43034,284379,26730,22038,480538,671021,802442,375658,890950,614629,37287,1040846,423529,349439,406842,610699,189896,523270,654285,358123,706183,554537,233970,277327,536343,478204,374118,963989,602693,35421,768054,524049,854046,553758,295138,826602,46467,120373,996764,536657,585554,1015446,462588,386830,856115,823629,928092,584554,275300,81365,152330,389781,856531,938983,1742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000903s ]