SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401028 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401028 [ RunTime:0.004007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909797,652485,956253,667447,161364,1047994,511825,947446,68943,776504,274978,170296,406554,70497,466830,599647,753888,536754,786168,592822,412886,849422,522366,390437,132918,241170,33162,409048,80263,728697,675023,310606,157126,691481,561275,943184,1014609,286380,98212,757411,652276,503058,77956,46988,850076,485550,969288,183533,960135,420267,790114,678615,336305,259471,347849,937398,513827,380618,422244,362821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]