SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 938503 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 938503 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406549,27463,202609,1041900,474922,39140,363322,470078,740463,881371,834931,330504,596044,283238,14960,1007475,797432,595104,566808,182894,124679,505818,990807,110860,444530,262817,429031,496259,800041,981620,505423,539529,358051,83200,185700,134568,599674,855698,281331,249674,656777,717847,489025,24417,603910,494173,620118,47645,970249,590705,755033,741061,339861,553088,412784,377679,108828,610083,741243,518297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 938503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 938503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]