SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417515 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417515 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (892328,360827,632420,1003251,744983,378,409459,788062,80027,22469,524747,815042,277582,613958,950904,501641,323039,699378,496821,203426,916004,786253,305552,938215,878665,161889,633479,851194,932708,667688,330432,282111,609702,1003495,197552,668883,444974,898328,411966,764497,991268,521166,784462,86512,132014,489202,921575,24499,927478,316070,429766,798703,95757,192639,942294,377902,25677,586379,551255,399683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]