SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466532 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466532 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796867,764578,960089,103223,658211,643501,494725,523364,947396,1032561,363553,69750,15336,486667,337078,491230,238397,374844,48884,814471,749487,737784,149636,577004,212513,594841,349196,619292,101953,191002,85813,715715,805147,107641,740195,419397,942507,544471,283931,231049,583721,299830,704969,703777,969615,744491,229459,566853,441553,991673,943477,186133,319900,392055,123776,363072,569935,70537,860029,626099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466532 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466532 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002495s ]