SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581283 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581283 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302041,774889,925360,124215,216670,212873,300536,799685,949554,561295,292658,713554,782029,200447,874164,602674,223956,229093,419458,330814,466548,402459,917974,134980,760235,446951,241236,1006713,907252,758501,674709,959133,758880,234603,931278,218415,486380,721816,871131,369585,981326,927433,477391,467199,523802,198497,208825,155189,405411,764331,928874,730543,719253,420622,93463,823233,39404,243321,109930,114440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000865s ]