SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512211 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512211 [ RunTime:0.002281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021860,460768,390384,824348,211179,901833,325636,38383,841618,175829,41424,286501,416578,624337,604585,936310,768580,356496,325502,160090,152317,883928,62508,921966,1037107,458344,896454,433710,291051,797372,725381,424219,1038010,764769,546040,396301,147576,459648,611634,620824,51298,908547,797969,293808,923376,306509,178742,871634,487273,487233,716553,201820,449491,262852,303441,442225,161813,329607,650086,731467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]