SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445268 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445268 [ RunTime:0.003417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018008,309626,840601,497333,794651,957770,799390,179218,11807,447837,584871,278771,594099,655739,401728,214374,839409,591088,739701,369103,965651,713360,48095,567892,112585,714442,233413,506388,951849,424169,343428,505000,169798,301355,282860,822567,791081,949027,577652,750280,68312,646791,35982,525930,796183,788841,886192,705223,880546,875189,753598,410240,646844,287270,915947,762520,374322,504510,901567,836502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002831s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445268 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445268 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]