SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409640 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409640 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153710,150212,743125,1027367,682861,390965,486764,401874,159619,172484,600987,518535,346668,377371,68537,1039589,189377,731310,310024,392904,873832,992347,143357,573099,936995,435183,706851,895413,345407,537593,180369,18980,267851,748701,388123,170978,955522,973110,909039,795182,934420,778300,733664,294162,187826,372495,243806,308690,617143,481897,428147,658482,382627,540948,16427,131481,932645,22557,179318,662362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]