SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44129 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44129 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (718978,966879,179418,397399,389742,946812,507231,514036,659381,86210,241656,278073,263126,561743,51485,92039,951918,891246,395041,668520,40633,521673,133182,251336,924707,262682,585856,204436,286033,727337,941940,956348,465932,938529,296374,749793,619798,103937,83277,724808,27136,552875,549265,421450,474092,735629,291301,655049,431354,692612,379494,30196,480601,527064,780695,449258,593056,637306,479370,1039952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44129 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44129 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002429s ]