SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004108 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004108 [ RunTime:0.002337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384942,944472,158315,843502,400224,753400,587598,13013,974140,49420,404399,31449,991157,200096,787811,736035,567172,709114,1014492,988701,79026,325094,329273,956194,821006,837427,789580,902060,159,117282,119570,580193,234903,839780,82615,933486,58477,1002998,84822,1048607,492827,709595,744575,847585,674482,460489,329732,528678,788298,344499,22808,563019,932918,893625,387708,360585,52053,153919,142772,843417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001097s ]