SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 791012 LIMIT 1 [ RunTime:0.001036s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 791012 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154913,642065,736966,855534,620431,515009,816273,494940,584587,622728,653326,241513,794888,762841,906173,933884,1002823,981960,155203,513240,991306,291028,224187,473753,167450,513147,169676,126018,161752,308614,109655,485462,519210,69367,483683,840,363835,492619,980909,100399,1021476,454891,873058,242061,1039609,269650,389139,162356,628971,472165,698181,524924,471500,727249,718219,227388,680442,225645,699149,269606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 791012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 791012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]