SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 247218 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 247218 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830411,436167,908156,52513,599510,481047,391140,982689,388449,95058,261418,235148,706687,853198,546300,598336,306926,574931,806096,751775,529298,956651,47756,457667,314708,439624,83629,680118,640993,528370,319539,526049,92322,408003,347845,838355,489107,438144,635742,307087,265065,157609,506359,49491,634077,369114,680978,793838,415474,618560,123011,147986,1023173,542590,670450,917492,385156,82087,471924,876857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 247218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 247218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]