SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840108 LIMIT 1 [ RunTime:0.001581s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840108 [ RunTime:0.004687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530441,737178,970787,120432,464166,536896,21942,254267,159922,250881,721152,695178,321838,728641,327270,140974,840474,826112,639258,97944,835447,517452,973648,369224,14480,520983,687184,528560,638475,95197,944096,390771,978340,471941,404538,113890,182797,693078,823866,990568,643050,507184,476854,963452,756430,585727,814488,297760,996969,157460,525490,924067,110919,878431,942505,198149,352699,525013,188052,708480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000733s ]