SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54152 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54152 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200168,351676,999734,180425,738152,380417,452690,330118,682141,338974,782900,492373,578641,709052,118898,410502,207332,702307,1030360,144939,358931,621130,493210,475490,993312,757336,968114,618218,682305,196608,974308,313810,150245,778158,614655,227972,436493,947527,17272,1035160,1045642,358203,303029,636195,436341,153446,560986,503033,800117,40053,710853,764215,633119,991184,181746,818262,191223,1045870,885908,752391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]