SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190417 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190417 [ RunTime:0.003334s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835262,223236,29099,446100,538027,108164,368441,751129,105903,641798,555926,294566,14647,1041219,514821,783509,623169,924468,770113,32422,837656,70328,781795,888541,886453,269732,634356,229923,598394,1039562,414118,989246,251265,457646,854713,300737,985067,1004602,951704,749463,642072,153549,388393,513440,230522,328570,898131,729188,727535,69532,291948,303816,660116,249195,158747,122028,847617,854095,261895,513618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]