SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043351 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043351 [ RunTime:0.002046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149399,527358,818005,189788,496950,686323,491575,82529,226912,496264,141591,467831,676135,1032177,777789,578597,605213,718708,287932,595453,705474,177094,470639,400334,144605,392965,201443,28237,565596,598708,158132,176259,338356,890947,926402,812844,542643,261187,31758,29913,356893,319609,439822,463423,748617,730724,224975,762193,806796,532588,507260,1010285,43958,342367,449349,438994,67756,96366,496316,407633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043351 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043351 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]