SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478073 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478073 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530277,101501,349062,1016777,231119,265983,592406,296664,160145,624619,322787,22246,50908,869925,968337,601307,446719,458179,1045935,824586,329311,404561,32990,357630,744648,816378,67295,475745,143170,844335,315019,34713,404110,959389,294657,843296,347889,281335,666407,532058,333773,691575,749110,714193,709175,193043,955929,155606,390,730231,586226,714875,55260,831581,11802,395362,801654,332737,652848,319174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000770s ]